<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/fationyyk/article/details/70144960"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql直接导出查询数据到文本 - 野蛮秘籍"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql直接导出查询数据到文本 - 野蛮秘籍 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "fationyyk";
        var blog_address = "https://blog.csdn.net/fationyyk";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/fationyyk/article/details/70144960"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql直接导出查询数据到文本";
        var articleDesc = "控制台直接输入以下命令比如导出mysql自带数据库中的user表信息mysql-h127.0.0.1-uroot-p-e“select*fromuser”mysql>info.txt输入mysql密码即可-h数据库服务器地址-u数据库用户名-p数据库密码-e查询条件语句后面跟上目标数据库（如例子中的mysql）info.txt导入的目标文件";
        // 第四范式所需数据
        var articleTitles = "mysql直接导出查询数据到文本 - 野蛮秘籍";
        
        var nickName = "野蛮秘籍";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/fationyyk/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/fationyyk/article/details/70144960";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql直接导出查询数据到文本</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年04月12日 16:53:19</span>
                    <a class="follow-nickName" href="https://me.csdn.net/fationyyk" target="_blank">野蛮秘籍</a>
                    <span class="read-count">阅读数 6286</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/fationyyk/article/details/70144960"> https://blog.csdn.net/fationyyk/article/details/70144960</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <p>控制台直接输入以下命令 <br>
比如导出mysql自带数据库中的user表信息</p>

<p>mysql -h127.0.0.1 -uroot -p -e “select *from user” mysql &gt; info.txt <br>
输入mysql密码即可</p>

<p>-h 数据库服务器地址 <br>
-u 数据库用户名 <br>
-p 数据库密码 <br>
-e 查询条件语句 后面跟上目标数据库（如例子中的mysql） <br>
info.txt 导入的目标文件</p>

<p>例子：</p>



<pre class="prettyprint"><code class=" hljs perl">mysql -uxxxx -p -hxxx -e <span class="hljs-string">"show databases;use xxx;select user_award_id,user_id,consumer_id,create_time,FROM_UNIXTIME(create_time,'<span class="hljs-variable">%Y</span>-<span class="hljs-variable">%m</span>-<span class="hljs-variable">%d</span> <span class="hljs-variable">%H</span>:<span class="hljs-variable">%i</span>:<span class="hljs-variable">%s</span>') from xxx where xxx = '' and xxx = '' ;"</span> &gt; user.txt</code></pre>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/fationyyk/article/details/70144960","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/fationyyk/article/details/70144960","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="70144960">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhanghe086/article/details/84175300","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhanghe086/article/details/84175300" target="_blank" title="mysql导出select结果到文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>导出</em>select结果到文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-26</span>
				<span class="read-num hover-hide">
					阅读数 
					21</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhanghe086/article/details/84175300" target="_blank" title="mysql导出select结果到文件">
				<span class="desc oneline">mysql-hxx-uxx-pxx-e&amp;quot;querystatement&amp;quot;db&amp;gt;file例如：mysql-h127.0.0.1-uroot-p000000-e&amp;quot;sele...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhanghe086">来自：	<span class="blog_title"> zhanghe086的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34072458/article/details/85996707","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34072458/article/details/85996707" target="_blank" title="把mysql的数据导出成txt">
		<h4 class="text-truncate oneline">
				把<em>mysql</em>的数据<em>导出</em>成txt		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-13</span>
				<span class="read-num hover-hide">
					阅读数 
					122</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34072458/article/details/85996707" target="_blank" title="把mysql的数据导出成txt">
				<span class="desc oneline">把mysql的数据导出成txtselectafrombintooutfile'/sqlfile/a.txt';my.ini里需要设置secure_file_priv=d:/sqlfile;linux中...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34072458">来自：	<span class="blog_title"> weixin_34072458的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012654154/article/details/73036789","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012654154/article/details/73036789" target="_blank" title="从mysql中导出一列数据到txt">
		<h4 class="text-truncate oneline">
				从<em>mysql</em>中<em>导出</em>一列数据到txt		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-11</span>
				<span class="read-num hover-hide">
					阅读数 
					9681</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012654154/article/details/73036789" target="_blank" title="从mysql中导出一列数据到txt">
				<span class="desc oneline">因为需要用到从师哥哪里获取到的mysql的评论数据，由于评论数据涉及到好多种属性，而我只需要获取其中的评论内容属性，对评论内容进行自然语言处理，所以就考虑到了将mysql中的数据导入到txt文件当中进...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012654154">来自：	<span class="blog_title"> u012654154的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/songxinfeng1989/article/details/80814874","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/songxinfeng1989/article/details/80814874" target="_blank" title="mysql将查询结果导出到excel中">
		<h4 class="text-truncate oneline">
				<em>mysql</em>将查询结果<em>导出</em>到excel中		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-26</span>
				<span class="read-num hover-hide">
					阅读数 
					3072</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/songxinfeng1989/article/details/80814874" target="_blank" title="mysql将查询结果导出到excel中">
				<span class="desc oneline">SELECT* fromlimit_recordINTOOUTFILE'e:/20180424.xls';SELECT* INTOOUTFILE'e:/20180424-2.xls'fromlimit...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/songxinfeng1989">来自：	<span class="blog_title"> songxinfeng1989的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yangguangqizhi/article/details/50505059","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yangguangqizhi/article/details/50505059" target="_blank" title="Linux下txt文件与mysql数据库导入导出">
		<h4 class="text-truncate oneline">
				Linux下txt文件与<em>mysql</em>数据库导入<em>导出</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-12</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yangguangqizhi/article/details/50505059" target="_blank" title="Linux下txt文件与mysql数据库导入导出">
				<span class="desc oneline">txt文本文件和mysql数据库之间相互导入导出是经常的事情，本文简要的介绍一下方法。   实验环境：Ubuntu14.04    Mysql 5.5（1）txt文件导入mysql数据库       ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yangguangqizhi">来自：	<span class="blog_title"> yangguangqizhi的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u013045437/article/details/81275960","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u013045437/article/details/81275960" target="_blank" title="mysql——通过命令将sql查询的结果导出到具体文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>——通过命令将sql查询的结果<em>导出</em>到具体文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-29</span>
				<span class="read-num hover-hide">
					阅读数 
					5820</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u013045437/article/details/81275960" target="_blank" title="mysql——通过命令将sql查询的结果导出到具体文件">
				<span class="desc oneline">引言最近在修改线上数据的时候，需要现将修改的数据继续备份，但是线上客户的服务器是不能直接连接，而是通过了一台堡垒机，这就说我们不能通过可视化客户端直接连接mysql的，所以所有的操作都是需要通过sql...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u013045437">来自：	<span class="blog_title"> 郑浩 架构师之路</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34272308/article/details/85656584","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34272308/article/details/85656584" target="_blank" title="MySQL 命令行导出、导入Select 查询结果">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 命令行<em>导出</em>、导入Select 查询结果		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-16</span>
				<span class="read-num hover-hide">
					阅读数 
					25</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34272308/article/details/85656584" target="_blank" title="MySQL 命令行导出、导入Select 查询结果">
				<span class="desc oneline">&amp;amp;lt;!--环境:Windows2003SP2+MySQL5.5.28Author:博客园小dee--&amp;amp;gt; 有的时候需要把在一张表中用select语句查询出来的结果保存到另一张结...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34272308">来自：	<span class="blog_title"> weixin_34272308的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhengwish/article/details/79217161","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhengwish/article/details/79217161" target="_blank" title="Mysql查询结果导出为Excel的几种方法">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>查询结果<em>导出</em>为Excel的几种方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-31</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhengwish/article/details/79217161" target="_blank" title="Mysql查询结果导出为Excel的几种方法">
				<span class="desc oneline">本想直接转发，奈何密码忘记了。原文复制过来吧。原文地址：https://www.cnblogs.com/qiaoyihang/p/6398673.html【我使用的是方法二】本文地址：http://w...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhengwish">来自：	<span class="blog_title"> zhengwish的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_27470131/article/details/78738311","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_27470131/article/details/78738311" target="_blank" title="Navicat导出指定查询条件的数据">
		<h4 class="text-truncate oneline">
				Navicat<em>导出</em>指定查询条件的数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_27470131/article/details/78738311" target="_blank" title="Navicat导出指定查询条件的数据">
				<span class="desc oneline">前提背景因为想做一个省-市-县-镇-村的行政区划的五级联动，所有就在网上找了一个mysql的数据库脚本，可是我只需要我们省的数据，所有就需要把数据过滤一下。在导出了原始数据以后，新建一个查询-输入查询...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_27470131">来自：	<span class="blog_title"> 不二雄的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fwj_ntu/article/details/87973212","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fwj_ntu/article/details/87973212" target="_blank" title="Mysql导出所有表名">
		<h4 class="text-truncate oneline">
				<em>Mysql</em><em>导出</em>所有表名		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-27</span>
				<span class="read-num hover-hide">
					阅读数 
					491</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fwj_ntu/article/details/87973212" target="_blank" title="Mysql导出所有表名">
				<span class="desc oneline">只想要导出表名，快速的操作是通过Mysql的命令行来实现。Navicat的工具栏提供了命令行的快速入口，点击工具——命令列界面就可以看见弹出的窗口：mysql&amp;amp;gt;showtables;执行...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fwj_ntu">来自：	<span class="blog_title"> fwj_ntu的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Lorenzo_D/article/details/51784925","strategy":"BlogCommendFromAutoMl2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Lorenzo_D/article/details/51784925" target="_blank" title="MySQL根据select语句导入导出数据（含解决中文乱码方式）">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>根据select语句导入<em>导出</em>数据（含解决中文乱码方式）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-29</span>
				<span class="read-num hover-hide">
					阅读数 
					2547</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Lorenzo_D/article/details/51784925" target="_blank" title="MySQL根据select语句导入导出数据（含解决中文乱码方式）">
				<span class="desc oneline">所有都亲测，不废话，上代码：导出selectcount(1)fromtable intooutfile'/tmp/test.xls'charactersetgbk;导入loaddatalocalinf...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Lorenzo_D">来自：	<span class="blog_title"> 代码次元袋</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u014094184/article/details/79963148","strategy":"BlogCommendFromAutoMl2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u014094184/article/details/79963148" target="_blank" title="MYSQL查询数据后导出到文件">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em><em>查询数据</em>后<em>导出</em>到文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-16</span>
				<span class="read-num hover-hide">
					阅读数 
					1549</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u014094184/article/details/79963148" target="_blank" title="MYSQL查询数据后导出到文件">
				<span class="desc oneline">将sql查询的数据使用excel导出，并使其不进行合并。selectslsid,oid,total,costintooutfile'/opt/lampp/aaa.csv'    fieldstermi...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u014094184">来自：	<span class="blog_title"> 莲小黏的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010139966/article/details/53522939","strategy":"BlogCommendFromAutoMl2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010139966/article/details/53522939" target="_blank" title="MySQL执行Select语句将结果导出到文件的方法">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>执行Select语句将结果<em>导出</em>到文件的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-08</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010139966/article/details/53522939" target="_blank" title="MySQL执行Select语句将结果导出到文件的方法">
				<span class="desc oneline">如果是对MySQL整个表数据导出，可以参照文章：http://www.crazyant.net/1355.html然而也会遇到的场景是，需要执行一个SQL语句，然后将SQL语句的结果输出到文件；方法一...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010139966">来自：	<span class="blog_title"> u010139966的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012965373/article/details/80607572","strategy":"BlogCommendFromAutoMl2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012965373/article/details/80607572" target="_blank" title="Mysql导入导出文本数据">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>导入<em>导出</em><em>文本</em>数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-07</span>
				<span class="read-num hover-hide">
					阅读数 
					246</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012965373/article/details/80607572" target="_blank" title="Mysql导入导出文本数据">
				<span class="desc oneline">导入数据：LOADDATAINFILE'c:/tmp/discounts.csv' INTOTABLEdiscounts FIELDSTERMINATEDBY','#分隔符ENCLOSEDBY'&amp;qu...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012965373">来自：	<span class="blog_title"> 杨鑫newlife的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_6192/article/details/82555041","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_6192/article/details/82555041" target="_blank" title="使用python将mysql的查询数据导出到文件">
		<h4 class="text-truncate oneline">
				使用python将<em>mysql</em>的<em>查询数据</em><em>导出</em>到文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-25</span>
				<span class="read-num hover-hide">
					阅读数 
					278</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_6192/article/details/82555041" target="_blank" title="使用python将mysql的查询数据导出到文件">
				<span class="desc oneline">mysql官方提供了很多种connector，其中包括python的connector。下载地址在：http://dev.mysql.com/downloads/connector/python/ 直...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_6192">来自：	<span class="blog_title"> iteye_6192的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/330125553","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<a href="https://bbs.csdn.net/topics/330125553" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>怎样把表的记录<em>导出</em>txt格式		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">03-02</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">mysql怎样把表的记录导出txt格式</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
	<div class="recommend-item-box  recommend-download-box clearfix"  data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/q123456789098/4333582","strategy":"BlogCommendFromBaidu","index":"16"}'>
		<a href="https://download.csdn.net/download/q123456789098/4333582" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>MySQL</em>查询结果<em>导出</em>到文件的另类方法.txt					</h4>
					<span class="data float-right">05-28</span>
				</div>
				<div class="desc oneline">
						MySQL查询结果导出到文件的另类方法.txt				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392390208","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<a href="https://bbs.csdn.net/topics/392390208" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>，查询后<em>导出</em>txt，如何把字段名也<em>导出</em>啊，百度也找不到，正文有语句，大家看看。		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-01</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">大家帮我看看，导出到txt后，没有wq5.`XINGJI`,sum(wq5.`DQYE`) 这两个字段，只有结果。。。 select wq5.`XINGJI`,sum(wq5.`DQYE`) from</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fhy569039351/article/details/81364582","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fhy569039351/article/details/81364582" target="_blank" title="mysql 数据库将 查询的数据导出为excel">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 数据库将 查询的数据<em>导出</em>为excel		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-02</span>
				<span class="read-num hover-hide">
					阅读数 
					1580</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fhy569039351/article/details/81364582" target="_blank" title="mysql 数据库将 查询的数据导出为excel">
				<span class="desc oneline">目录方法一：查询语句直接输出方法二：在shell命令行下操作方式三:在shell命令行下操作个人总结：方法一：查询语句直接输出分为两步：1、在mysqlcmd中或者可视化工具（如：SQLyog）中输入...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fhy569039351">来自：	<span class="blog_title"> 相由心生的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/tpstu/article/details/44339863","strategy":"BlogCommendFromAutoMl2","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/tpstu/article/details/44339863" target="_blank" title="如何把mysql数据导出成文本文件">
		<h4 class="text-truncate oneline">
				如何把<em>mysql</em>数据<em>导出</em>成<em>文本</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-17</span>
				<span class="read-num hover-hide">
					阅读数 
					6750</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/tpstu/article/details/44339863" target="_blank" title="如何把mysql数据导出成文本文件">
				<span class="desc oneline">导出结构和数据：1.mysql&gt; use dbnameDatabase Changed mysql&gt; select * from driver into outfile 'a.txt'; 2.C:\&gt;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/tpstu">来自：	<span class="blog_title"> tpstu的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhi_heart/article/details/43965907","strategy":"BlogCommendFromAutoMl2","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhi_heart/article/details/43965907" target="_blank" title="mysql导入数据load data infile用法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>导入数据load data infile用法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-27</span>
				<span class="read-num hover-hide">
					阅读数 
					290</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhi_heart/article/details/43965907" target="_blank" title="mysql导入数据load data infile用法">
				<span class="desc oneline">mysql导入数据loaddatainfile用法基本语法：loaddata[low_priority][local]infile'file_nametxt'[replace|ignore]intot...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhi_heart">来自：	<span class="blog_title"> zhi_heart的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hwhua1986/article/details/53431852","strategy":"BlogCommendFromAutoMl2","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hwhua1986/article/details/53431852" target="_blank" title="mysql：如何将命令行结果数据输出到文本文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>：如何将命令行结果数据输出到<em>文本</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-02</span>
				<span class="read-num hover-hide">
					阅读数 
					5251</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hwhua1986/article/details/53431852" target="_blank" title="mysql：如何将命令行结果数据输出到文本文件">
				<span class="desc oneline">最近碰到一个问题，就是通过showvariables查看mysql配置信息的时候，由于数据行较多，cmd命令有些查看不到，那么就需要用一种办法将屏幕的结果输出到文件中来查看。方法就是通过重定向的方式将...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hwhua1986">来自：	<span class="blog_title"> 测试蜗牛，一步一个脚印</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/singinneteasy/article/details/17718625","strategy":"BlogCommendFromAutoMl2","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/singinneteasy/article/details/17718625" target="_blank" title="mysql 导出数据到txt文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>导出</em>数据到txt文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-31</span>
				<span class="read-num hover-hide">
					阅读数 
					1017</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/singinneteasy/article/details/17718625" target="_blank" title="mysql 导出数据到txt文件">
				<span class="desc oneline">示例： SELECTemailFROMxxxxxxwhereemailisnotnullandemail 说明：1.导出文件目录：修改输出文件名的目录，以便放在指定的位置。如'a.txt'可以改成'....</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/singinneteasy">来自：	<span class="blog_title"> 大庄园</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/eric509/article/details/83972956","strategy":"BlogCommendFromAutoMl2","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/eric509/article/details/83972956" target="_blank" title="MySQL查询结果导出到文件 ">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>查询结果<em>导出</em>到文件 		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-19</span>
				<span class="read-num hover-hide">
					阅读数 
					104</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/eric509/article/details/83972956" target="_blank" title="MySQL查询结果导出到文件 ">
				<span class="desc oneline">选择某些行作为需要的数据 SELECTid,dbnameFROM`index`intooutfile&amp;quot;d://aaa.txt&amp;quot;; 一般大家都会用“SELECTINTOOUTFIL”...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/eric509">来自：	<span class="blog_title"> eric的学习笔记</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/TH_NUM/article/details/79813173","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/TH_NUM/article/details/79813173" target="_blank" title="mysql查询结果输出到文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查询结果输出到文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-04</span>
				<span class="read-num hover-hide">
					阅读数 
					2259</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/TH_NUM/article/details/79813173" target="_blank" title="mysql查询结果输出到文件">
				<span class="desc oneline">mysql查询结果导出/输出/写入到文件方法一：直接执行命令：mysql&amp;amp;gt;selectcount(1)fromtableintooutfile'/tmp/test.xls';QueryO...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/TH_NUM">来自：	<span class="blog_title"> TH_NUM的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fdipzone/article/details/48399831","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fdipzone/article/details/48399831" target="_blank" title="mysql导出查询结果到csv方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>导出</em>查询结果到csv方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-12</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fdipzone/article/details/48399831" target="_blank" title="mysql导出查询结果到csv方法">
				<span class="desc oneline">将mysql的查询结果导出为csv，一般会使用php连接mysql执行查询，将返回的查询结果使用php生成csv格式再导出。但这样比较麻烦，需要服务器安装php才可以实现。如果可以直接使用mysql导...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fdipzone">来自：	<span class="blog_title"> 傲雪星枫</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/M983373615/article/details/81098718","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/M983373615/article/details/81098718" target="_blank" title="数据库导出成txt文件">
		<h4 class="text-truncate oneline">
				数据库<em>导出</em>成txt文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-18</span>
				<span class="read-num hover-hide">
					阅读数 
					652</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/M983373615/article/details/81098718" target="_blank" title="数据库导出成txt文件">
				<span class="desc oneline">脚本原型：#!/bin/shclearecho&amp;quot;connectDatabase&amp;quot;echo&amp;quot;PleaseEnterUserName-&amp;amp;gt;&amp;quot;|tr-d&amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/M983373615">来自：	<span class="blog_title"> M983373615的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390345138","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<a href="https://bbs.csdn.net/topics/390345138" target="_blank">
		<h4 class="text-truncate oneline">
				简单的 <em>Mysql</em> 输出语句 		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">01-12</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">这是例子 我的 table 里面有2个column,3个row,数据是这样的 : {名字:兴杰 ，薪水:5千} , {名字:张三 ，薪水:10千},{名字:李四 ，薪水:15千} 我用 select</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yufei2999/article/details/84175673","strategy":"BlogCommendFromAutoMl2","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yufei2999/article/details/84175673" target="_blank" title="MSSQL数据导出文本（来自本论坛）">
		<h4 class="text-truncate oneline">
				MSSQL数据<em>导出</em><em>文本</em>（来自本论坛）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-27</span>
				<span class="read-num hover-hide">
					阅读数 
					26</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yufei2999/article/details/84175673" target="_blank" title="MSSQL数据导出文本（来自本论坛）">
				<span class="desc oneline">网址：http://dl.iteye.com/topics/download/a466bcbc-37a9-3e73-ae0a-6b8ed236d626</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yufei2999">来自：	<span class="blog_title"> yufei2999的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_41080850/article/details/86655914","strategy":"BlogCommendFromAutoMl2","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_41080850/article/details/86655914" target="_blank" title="MySQL查询结果导出方式总结">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>查询结果<em>导出</em>方式总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-26</span>
				<span class="read-num hover-hide">
					阅读数 
					684</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_41080850/article/details/86655914" target="_blank" title="MySQL查询结果导出方式总结">
				<span class="desc oneline">说明：以下示例中使用的MySQL版本为MySQL8.0.13，Python版本为Python3.6.4，数据库第三方客户端NavicatPremium版本为12.0.18方法一：利用select···...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_41080850">来自：	<span class="blog_title"> Backcanhave7</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jordanmicle/article/details/83812523","strategy":"BlogCommendFromAutoMl2","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jordanmicle/article/details/83812523" target="_blank" title="PHP生成TXT文件">
		<h4 class="text-truncate oneline">
				PHP生成TXT文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-16</span>
				<span class="read-num hover-hide">
					阅读数 
					32</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jordanmicle/article/details/83812523" target="_blank" title="PHP生成TXT文件">
				<span class="desc oneline">访问PHP的时候生成TXT并自动下载。 第一步：处理中文文件名：$ua=$_SERVER[&amp;quot;HTTP_USER_AGENT&amp;quot;];$filename=&amp;quot;中文文件名.txt&amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jordanmicle">来自：	<span class="blog_title"> 风继续吹</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hanwenyi520/article/details/51518379","strategy":"BlogCommendFromAutoMl2","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hanwenyi520/article/details/51518379" target="_blank" title="mysql批量导出、导入文本数据">
		<h4 class="text-truncate oneline">
				<em>mysql</em>批量<em>导出</em>、导入<em>文本</em>数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-27</span>
				<span class="read-num hover-hide">
					阅读数 
					675</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hanwenyi520/article/details/51518379" target="_blank" title="mysql批量导出、导入文本数据">
				<span class="desc oneline">mysql常用的insert语句:INSERTINTO`test`(`code_no`,`coupon_price`,`get_mobile`,`get_order_code`,`code_get_t...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hanwenyi520">来自：	<span class="blog_title"> henry</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chenpe32cp/article/details/70552837","strategy":"BlogCommendFromAutoMl2","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chenpe32cp/article/details/70552837" target="_blank" title="如何向mysql数据库中导入或导出txt文件">
		<h4 class="text-truncate oneline">
				如何向<em>mysql</em>数据库中导入或<em>导出</em>txt文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1402</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chenpe32cp/article/details/70552837" target="_blank" title="如何向mysql数据库中导入或导出txt文件">
				<span class="desc oneline">转载于此学习总结基本的MySQL数据库导入导出操作www.2cto.com1表tt的格式：CREATETABLEtt(indintNOTNULLauto_increment,namechar(100)...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chenpe32cp">来自：	<span class="blog_title"> chenpe32cp的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/baochanghong/article/details/53018541","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/baochanghong/article/details/53018541" target="_blank" title="mysql数据导入导出方法总结">
		<h4 class="text-truncate oneline">
				<em>mysql</em>数据导入<em>导出</em>方法总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-03</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/baochanghong/article/details/53018541" target="_blank" title="mysql数据导入导出方法总结">
				<span class="desc oneline">MySQL数据备份还原方式总结：一、将数据导入到指定的数据库第一种导入方式：（linux下和Windows 下语法是一样的，只是路劲的书写方式不同而已） 1、创建一个空数据库 2、进入MySQL安装目...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/baochanghong">来自：	<span class="blog_title"> baochanghong的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390514497","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<a href="https://bbs.csdn.net/topics/390514497" target="_blank">
		<h4 class="text-truncate oneline">
				linux下<em>mysql</em><em>导出</em>txt文件问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">07-10</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">linux下的mysql 表是utf8，导出的txt能不能是ucs2的（支持多国语言），我看了下导出都是ANSI编码方式</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wuhuagu_wuhuaguo/article/details/73805962","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wuhuagu_wuhuaguo/article/details/73805962" target="_blank" title="mysql命令行的导入导出sql,txt,excel（都在linux或windows命令行操作）">
		<h4 class="text-truncate oneline">
				<em>mysql</em>命令行的导入<em>导出</em>sql,txt,excel（都在linux或windows命令行操作）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-27</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wuhuagu_wuhuaguo/article/details/73805962" target="_blank" title="mysql命令行的导入导出sql,txt,excel（都在linux或windows命令行操作）">
				<span class="desc oneline">Mysql导入导出sql,txt,excel（都在linux或windows命令行操作）首先我们通过命令行进入到mysql安装目录的bin目录下，比如我输入的命令行为： d:cd D:/wamp/bi...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wuhuagu_wuhuaguo">来自：	<span class="blog_title"> wuhuagu_wuhuaguo的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/alzhuzhu/article/details/50536775","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/alzhuzhu/article/details/50536775" target="_blank" title="MySQL使用SELECT...INTO OUTFILE导出文本文件">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>使用SELECT...INTO OUTFILE<em>导出</em><em>文本</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-18</span>
				<span class="read-num hover-hide">
					阅读数 
					2000</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/alzhuzhu/article/details/50536775" target="_blank" title="MySQL使用SELECT...INTO OUTFILE导出文本文件">
				<span class="desc oneline">MySQL中，可以使用SELECT...INTOOUTFILE语句将表的内容导出为一个文本文件。其基本的语法格式如下：SELECT[列名]FROMtable[WHERE语句]INTOOUTFILE'目...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/alzhuzhu">来自：	<span class="blog_title"> 黑坑的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u013473691/article/details/52237955","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u013473691/article/details/52237955" target="_blank" title="mysql中导入txt文件数据的操作指令">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中导入txt文件数据的操作指令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-18</span>
				<span class="read-num hover-hide">
					阅读数 
					6572</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u013473691/article/details/52237955" target="_blank" title="mysql中导入txt文件数据的操作指令">
				<span class="desc oneline">1表tt的格式：  CREATETABLE`tt`( `ind`intNOTNULLauto_increment, `name`char(100)defaultNULL, PRIMARYKEY (`i...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u013473691">来自：	<span class="blog_title"> 码农</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34268579/article/details/92518719","strategy":"BlogCommendFromAutoMl2","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34268579/article/details/92518719" target="_blank" title="mysql 将查询结果导出到文本">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 将查询结果<em>导出</em>到<em>文本</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-05</span>
				<span class="read-num hover-hide">
					阅读数 
					10</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34268579/article/details/92518719" target="_blank" title="mysql 将查询结果导出到文本">
				<span class="desc oneline">将mysql查询结果导出到文本文件mysql&amp;gt;pagercat&amp;gt;/tmp/test.txtselect*fromuser;查询结果输出到/tmp/test.txt中				转载于:http...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34268579">来自：	<span class="blog_title"> weixin_34268579的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Q1059081877Q/article/details/50699705","strategy":"BlogCommendFromAutoMl2","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Q1059081877Q/article/details/50699705" target="_blank" title="mysql txt文件的导入导出">
		<h4 class="text-truncate oneline">
				<em>mysql</em> txt文件的导入<em>导出</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-19</span>
				<span class="read-num hover-hide">
					阅读数 
					2005</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Q1059081877Q/article/details/50699705" target="_blank" title="mysql txt文件的导入导出">
				<span class="desc oneline">mysqltxt文件的导入导入文件要求 每一项之间用Tab键进行分隔，如果该字段为NULL，则用\N表示。loaddatalocalinfile&quot;/home/xueqy/data.txt&quot;intota...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Q1059081877Q">来自：	<span class="blog_title"> 薛秋艳的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/simon_lin/article/details/83172586","strategy":"BlogCommendFromAutoMl2","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/simon_lin/article/details/83172586" target="_blank" title="MYSQL 导入 txt文件">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em> 导入 txt文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-17</span>
				<span class="read-num hover-hide">
					阅读数 
					168</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/simon_lin/article/details/83172586" target="_blank" title="MYSQL 导入 txt文件">
				<span class="desc oneline">今天同事问起MySQL导入txt文件...用mysqlimport工具。~帮忙调试。。。。自己测试通过mysqlimport-uroot-padmin-d --fields-terminated-by...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/simon_lin">来自：	<span class="blog_title"> 咧着的嘴巴</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/gjf281/article/details/46787991","strategy":"BlogCommendFromAutoMl2","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gjf281/article/details/46787991" target="_blank" title="Navicat导出mysql的查询结果为Excel文档">
		<h4 class="text-truncate oneline">
				Navicat<em>导出</em><em>mysql</em>的查询结果为Excel文档		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gjf281/article/details/46787991" target="_blank" title="Navicat导出mysql的查询结果为Excel文档">
				<span class="desc oneline"></span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yanmou8222/article/details/82114753","strategy":"BlogCommendFromAutoMl2","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yanmou8222/article/details/82114753" target="_blank" title="linux命令行下使用mysql，怎么导出查询的记录集">
		<h4 class="text-truncate oneline">
				linux命令行下使用<em>mysql</em>，怎么<em>导出</em>查询的记录集		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-27</span>
				<span class="read-num hover-hide">
					阅读数 
					1118</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yanmou8222/article/details/82114753" target="_blank" title="linux命令行下使用mysql，怎么导出查询的记录集">
				<span class="desc oneline">用命令select*fromtableintooutfile‘xxx.txt’;就可以把查询数据导出在当前数据库保存位置的xxx.txt文件里面了。也可以直接在linux命令用mysql-h127.0...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yanmou8222">来自：	<span class="blog_title"> yanmou8222的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhang434/article/details/12917481","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhang434/article/details/12917481" target="_blank" title="mysql导入及导出txt文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>导入及<em>导出</em>txt文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-21</span>
				<span class="read-num hover-hide">
					阅读数 
					2834</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhang434/article/details/12917481" target="_blank" title="mysql导入及导出txt文件">
				<span class="desc oneline">导入数据库:mysql&gt;usedatabasename;mysql&gt;loaddatainfile&quot;E:\\test\\test.txt&quot;intotabletablenamefieldsterminat...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhang434">来自：	<span class="blog_title"> zhang434的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390941216","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<a href="https://bbs.csdn.net/topics/390941216" target="_blank">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>批量导入17770个txt文件并且处理数据、建表的问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">11-26</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我有两个数据， movies.txt 具体看下图 属性是 电影ID，电影发行时间，电影名称 每个电影的评分 因为有17770个电影，所以我有17770个txt文件，每个文件表示用户对一个电影的评分 如</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhengwei125/article/details/51968639","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhengwei125/article/details/51968639" target="_blank" title="mysql&amp;Oracle导入导出txt格式的数据">
		<h4 class="text-truncate oneline">
				<em>mysql</em>&amp;Oracle导入<em>导出</em>txt格式的数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-20</span>
				<span class="read-num hover-hide">
					阅读数 
					1670</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhengwei125/article/details/51968639" target="_blank" title="mysql&amp;Oracle导入导出txt格式的数据">
				<span class="desc oneline">一:mysql导入数据loaddatainfile用法导出一张表的数据，以','为分隔符select*frompet into outfile'c:/pet.txt'  fieldsterminate...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhengwei125">来自：	<span class="blog_title"> 小伟的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/bushuwei/article/details/88842630","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bushuwei/article/details/88842630" target="_blank" title="mysql 查询导出(txt,csv,xls)">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 查询<em>导出</em>(txt,csv,xls)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-27</span>
				<span class="read-num hover-hide">
					阅读数 
					50</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bushuwei/article/details/88842630" target="_blank" title="mysql 查询导出(txt,csv,xls)">
				<span class="desc oneline">１　简介　　工作中产品经常会临时找我导出一些数据，导出mysql查询结果数据有几种方法，下面介绍３种．　　　①mysql-u-p-e&quot;sql&quot;db&amp;gt;filepath　　　②echo&quot;sql&quot;|l...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bushuwei">来自：	<span class="blog_title"> bushuwei的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/KHZ_222/article/details/88391571","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/KHZ_222/article/details/88391571" target="_blank" title="20190311 MySQL导出到csv文本,EXCEL表格">
		<h4 class="text-truncate oneline">
				20190311 <em>MySQL</em><em>导出</em>到csv<em>文本</em>,EXCEL表格		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-11</span>
				<span class="read-num hover-hide">
					阅读数 
					93</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/KHZ_222/article/details/88391571" target="_blank" title="20190311 MySQL导出到csv文本,EXCEL表格">
				<span class="desc oneline">导出到csvhttps://www.mysqltutorial.org/mysql-export-table-to-csv/SELECTorderNumber,orderDate,IFNULL(shi...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/KHZ_222">来自：	<span class="blog_title"> Jimmy的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yjqyyjw/article/details/84566956","strategy":"BlogCommendFromAutoMl2","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yjqyyjw/article/details/84566956" target="_blank" title="【MySQL】Linux服务器将Mysql查询结果导出为Excel的几种方法">
		<h4 class="text-truncate oneline">
				【<em>MySQL</em>】Linux服务器将<em>Mysql</em>查询结果<em>导出</em>为Excel的几种方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-27</span>
				<span class="read-num hover-hide">
					阅读数 
					2366</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yjqyyjw/article/details/84566956" target="_blank" title="【MySQL】Linux服务器将Mysql查询结果导出为Excel的几种方法">
				<span class="desc oneline">方法一：查询语句直接输出语法格式：select*intooutfile'/data/var-3307/catid.xls'fromhelp_catwhere1orderbycat_iddesclimi...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yjqyyjw">来自：	<span class="blog_title"> Jack小强</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_40809627/article/details/83183734","strategy":"BlogCommendFromAutoMl2","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_40809627/article/details/83183734" target="_blank" title="mysql 查询数据导出到文件中">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>查询数据</em><em>导出</em>到文件中		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-19</span>
				<span class="read-num hover-hide">
					阅读数 
					63</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_40809627/article/details/83183734" target="_blank" title="mysql 查询数据导出到文件中">
				<span class="desc oneline">select*fromods_log_tomcat_mobileINTOOUTFILE‘/tmp/daily_report/debt_financing/24EXPORTBUSINESSZHAIQ.t...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_40809627">来自：	<span class="blog_title"> weixin_40809627的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtzakgtsZWR1.html" target="_blank">
                        直接学python</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtDaEgysNi1lZHUO0O0O.html" target="_blank">
                        python查询数据使用教程</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/fationyyk">
              <img src="https://avatar.csdn.net/F/E/8/3_fationyyk.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/11.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/fationyyk"  class="" id="uid">野蛮秘籍</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="129">
                        <dt><a href="https://blog.csdn.net/fationyyk?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/fationyyk?t=1"><span class="count">129</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="32">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">32</span></dd>
        </dl>
        <dl class="text-center" title="30">
            <dt>喜欢</dt>
            <dd><span class="count">30</span></dd>
        </dl>
        <dl class="text-center" title="30">
            <dt>评论</dt>
            <dd><span class="count">30</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="5级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-5"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="466621">
                46万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="4821">
                4821            </dd>
        </dl>
        <dl title="10779">
            <dt>排名：</dt>
            <dd>1万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/fationyyk">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/fationyyk/article/details/85149124" target="_blank" >
                                        设计模式之装饰器模式                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/fationyyk/article/details/85110061" target="_blank" >
                                        设计模式之策略模式                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/fationyyk/article/details/85085005" target="_blank" >
                                        设计模式之工厂模式                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/fationyyk/article/details/85010408" target="_blank" >
                                        Redis面试定期更新                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/fationyyk/article/details/84995924" target="_blank" >
                                        PHP获取ip地址（REMOTE_ADDR，HTTP_VIA， HTTP_X_FORWARDED_FOR）                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/2166299">
                    <span class="title oneline">PHP</span>
                    <span class="count float-right">33篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/2177443">
                    <span class="title oneline">MySQL数据库</span>
                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/2179945">
                    <span class="title oneline">Jquery</span>
                    <span class="count float-right">11篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6125465">
                    <span class="title oneline">Laravel框架</span>
                    <span class="count float-right">23篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6125637">
                    <span class="title oneline">web安全</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6137342">
                    <span class="title oneline">ThinkPHP框架</span>
                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6138412">
                    <span class="title oneline">Composer探索</span>
                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6168458">
                    <span class="title oneline">wampserver</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6171388">
                    <span class="title oneline">正则表达式</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6198695">
                    <span class="title oneline">Linux</span>
                    <span class="count float-right">30篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6206027">
                    <span class="title oneline">javascript</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6209310">
                    <span class="title oneline">环境搭建</span>
                    <span class="count float-right">15篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6211386">
                    <span class="title oneline">win7系统</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6253561">
                    <span class="title oneline">算法</span>
                    <span class="count float-right">21篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6861624">
                    <span class="title oneline">mac</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/6913162">
                    <span class="title oneline">设计模式</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/fationyyk/article/category/8533775">
                    <span class="title oneline">Redis</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2018/12">
                    2018年12月                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2018/04">
                    2018年4月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2018/01">
                    2018年1月                    <span class="count float-right">14篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2017/12">
                    2017年12月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2017/08">
                    2017年8月                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2017/07">
                    2017年7月                    <span class="count float-right">31篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2017/05">
                    2017年5月                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2017/04">
                    2017年4月                    <span class="count float-right">14篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2016/06">
                    2016年6月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2016/05">
                    2016年5月                    <span class="count float-right">22篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2016/04">
                    2016年4月                    <span class="count float-right">20篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2016/03">
                    2016年3月                    <span class="count float-right">32篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2014/04">
                    2014年4月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/fationyyk/article/month/2012/12">
                    2012年12月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/fationyyk/article/details/51333336" >
                                                a标签置灰不可点击                    </a>
					<p class="read">阅读数 <span>70093</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/fationyyk/article/details/51353041" >
                                                Laravel5.* 打印出执行的sql语句                    </a>
					<p class="read">阅读数 <span>24377</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/fationyyk/article/details/50856730" >
                                                Laravel框架学习（使用DB门面操作数据库 原生SQL）                    </a>
					<p class="read">阅读数 <span>23637</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/fationyyk/article/details/50848293" >
                                                Laravel框架学习（Request请求数据、Cookie、文件上传）                    </a>
					<p class="read">阅读数 <span>20765</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/fationyyk/article/details/79071204" >
                                                phpstorm git使用                    </a>
					<p class="read">阅读数 <span>17817</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/fationyyk/article/details/79178327#comments">mac VPN连接 L2TP－VP...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/li_haijiang" class="user-name" target="_blank">li_haijiang：</a>牛逼 , 可以 , 但是第二行的空格要删掉                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/fationyyk/article/details/70213373#comments">js获取上传图片宽高</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/xcy1193068639" class="user-name" target="_blank">xcy1193068639：</a>[reply]weixin_36411160[/reply]
传进去的是方法，参数都是形参                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/fationyyk/article/details/79178327#comments">mac VPN连接 L2TP－VP...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_38403092" class="user-name" target="_blank">qq_38403092：</a>不行,可还有其他办法，我的windows可以正常访问，就mac不行                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/fationyyk/article/details/79071204#comments">phpstorm git使用</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_42085115" class="user-name" target="_blank">weixin_42085115：</a>谢谢楼主                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/fationyyk/article/details/75228347#comments">PHP实现数组中两个数的和等于给定...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_39131177" class="user-name" target="_blank">qq_39131177：</a>[reply]hello_sgw[/reply]
$arr = [3,3,3,3]; twoSum($arr,6);就有错  包括三个数的时候也有错                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/fationyyk/article/details/70144597" title="PHP new staic() 和 new self()的区别">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/fationyyk/article/details/70159416" title="PHP 常用命令行">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/fationyyk/article/details/70144597" title="PHP new staic() 和 new self()的区别">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/fationyyk/article/details/70159416" title="PHP 常用命令行">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "70144960";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/fationyyk/article/details/70144960";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql直接导出查询数据到文本 - 野蛮秘籍";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u76f4\u63a5","\u5bfc\u51fa","\u67e5\u8be2\u6570\u636e","\u6587\u672c"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
